EMT Practice Test

1. Question Content...

---

Question1: How can you view the contents of a CAS table?

Question2: Which CAS action is used to perform a cross-tabulation of two categorical variables in a CAS table?

Question3: What is the purpose of the PROMOTE action in CAS?

Question4: Which SQL clause is used to filter rows in a CAS table based on specified conditions?

Question5: Which PROC CASUTIL statement successfully applies the regnm format to the Region column of the sales table in the public caslib?

Question6: Which CAS-enabled procedure is used to create user-defined formats?

Question7: When submitted, this program runs normally on the Compute Server and produces a cross-tab report:
proc freq data=casuser.cars;
by descending origin;
table type*make / nocol norow nopercent;
run;
What happens when this program is submitted instead?
proc freqtab data=casuser.cars;
by descending origin;
table type*make / nocol norow nopercent;
run;

Question8: Which CAS action is used to filter rows in a CAS table based on specified conditions?

Question9: Which CAS action is used to execute a DATA step program in SAS CAS?

Question10: Which statement is true about SAS Viya?

Question11: Which CAS-enabled procedure is used to perform market basket analysis?

Question12: Which CAS statement is used to load data from an external file into a CAS table?

Question13: Which statements are true about CASL? (Select two)

Question14: What is the purpose of the CASLIB statement in SAS Viya?

Question15: What is the file extension used for SAS Viya programs?

Question16: Which PROC CASUTIL step suppresses error messages if the table is not found in-memory?

Question17: Which Compute Server system option prevents inadvertently moving large in-memory tables to the Compute Server?

Question18: You want to use the MEANS procedure to summarize data using the CAS server.
Which statement is true?

Question19: Which CAS-enabled procedure is used to fit regression models?

Question20: Which CAS action is used to delete a CAS table from memory?

Question21: Which CAS action is used to delete a CASLIB?

Question22: The table casuser.employees is partitioned onto 3 CAS worker nodes.
Which SAS program will correctly accumulate a total of the salary variable and store it in the variable totalSalary?

Question23: Which CAS statement is used to join two or more CAS tables based on a common key variable?

Question24: DATA step performance in CAS is most affected:

Question25: Which CAS action is used to calculate the frequency and percentage of values for categorical variables in a CAS table?

Question26: Which CAS-enabled procedure is used for data exploration and visualization?

Question27: In the DATA step, which statement is used to conditionally execute code?

Question28: Which SAS Viya component is responsible for distributed data processing?

Question29: Which CAS statement is used to create a new column in a CAS table?

Question30: What is the purpose of the WHERE clause in CAS language programming?

Question31: Which CAS action is used to identify potential duplicate records in a CAS table?

Question32: Which CAS action is used to calculate the correlation matrix for numeric variables in a CAS table?

Question33: Which CAS action is used to perform outlier detection on numeric variables in a CAS table?

Question34: Which CAS-enabled procedure is used to perform time series analysis on CAS tables?

Question35: When creating SAS graphs on extremely large CAS tables, the best practice is to:

Question36: Which statement will show all available caslibs in the log?

Question37: Which statement is true about the Compute Server?

Question38: Given the following SAS program:
proc mdsummary data=casuser.orders;
var RetailPrice;
output out=casuser.orders_sum;
run;
Which CAS action produces the same result as the code above without ERROR if you run it twice?

Question39: Which CAS-enabled procedure is used to perform linear regression analysis on CAS tables?

Question40: Which DATA step statement is used to conditionally assign values to variables based on specified conditions?

Question41: Complete the code below to create an in-memory table named cars_cas in the casuser caslib.
proc casutil;
load data=sashelp.cars outcaslib="casuser" casout=__________;
run;

Question42: Given the following array: x={"May", "August", "September"};
What is the correct reference to the element containing the value May?

Question43: Which CAS action is used to append rows to an existing CAS table?

Question44: What is the purpose of the APPEND action in CAS language programming?

Question45: What is the purpose of the BY statement in the DATA step?

Question46: In the space below, add 1 character to complete the syntax.
proc cas;
table.tableDetails Answer
aslib="casuser", name=employees";
quit;

Question47: What is the purpose of the WHERE clause in CAS actions?

Question48: What is the purpose of the SELECT statement in SQL programming?

Question49: Which CAS-enabled procedure is used for descriptive statistics and data summarization?

Question50: What CASL data type is created from the following assignment statement?
half = 1/2;

Question51: Which CAS-enabled procedure is used to perform text analytics?

Question52: Which DATA step statement is used to read data from an external file in CAS programming?

Question53: Complete the SAS program below to generate a table named cost_cont in the casuser caslib that contains the statistics for each value of continent.
proc mdsummary data=casuser.orders;
var cost;
groupby continent /_______;
run;

Question54: Given the following SAS program:
data casuser.national;
set casuser.baseball(where=(league='National'));
r=ranuni(625);
drop league;
run;
Why is the above program processed by the Compute Server rather than the CAS server?

Question55: Which data types are supported by CAS tables?

Question56: How can you rename a CAS table in CAS?

Question57: Which CAS action is used to perform aggregations and summary statistics?

Question58: Which SAS Viya component is responsible for executing CAS-enabled procedures?

Question59: Which CAS-enabled procedure is used to perform text mining on CAS tables?

Question60: Which SAS Viya component is responsible for storing and managing user-defined formats?

Question61: Which statement is FALSE regarding loading data into CAS?

Question62: Which CAS action is used to calculate the sum, minimum, maximum, and mean for numeric variables in a CAS table?

Question63: Which CASL program will create the sample2 table in the casuser caslib?

Question64: Which statement is true regarding BY group processing in the CAS DATA step?

Question65: Which CAS action is used to validate the integrity of relationships between variables in a CAS table?

Question66: Which SAS Viya procedure is used for data summarization and descriptive statistics?

Question67: Which CAS server component distributes data and code for processing?

Question68: Which CASL program correctly adds the Sales caslib to access data in the /data/sales folder?

Question69: Which programming language is primarily used in CAS?

Question70: Which CAS action is used to create a new CASLIB?

Question71: What is the primary programming language used in SAS Viya?

Question72: Which CAS action is used to recode the values of a categorical variable in a CAS table?

Question73: Which SQL clause is used to sort rows in a CAS table based on specified variables?

Question74: What is the primary purpose of the DATA step in SAS CAS?

Question75: Which SQL clause is used to calculate summary statistics for variables in a CAS table?

Question76: Given the CAS table casuser.shoes and the following SAS program:
data casuser.shoes2(where=(region="Africa" and Product="Slipper"));
set casuser.shoes;
keep Region Product Sales;
run;
Which statement is true?

Question77: Select the correct way to define formats and labels in a FedSQL CREATE TABLE statement.

Question78: Which SAS program will list tables contained in caslib public?

Question79: What is the primary advantage of using CAS-enabled procedures in SAS?

Question80: Which CAS-enabled procedure is used to apply user-defined formats to variables?

Question81: In the DATA step, which statement is used to output the processed data?

Question82: Which code can be used to load a SAS data set, sashelp.cars, into caslib public?

Question83: Which CAS action is used to execute SQL queries in SAS CAS?

Question84: Which CAS action is used to select specific columns from a CAS table?

Question85: Which SAS Viya component is used for creating interactive dashboards and reports?

Question86: Which CAS action is used to import data into CAS?

Question87: What is a CAS table in CAS?

Question88: Which CAS action is used to perform aggregations and summary statistics in the DATA step?

Question89: Given the dictionary inTable : {caslib="casuser",name="cars"}
Which CASL statement will successfully add a where parameter to subset the data?

Question90: Which CAS statement is used to perform data manipulation operations like filtering and transforming data?

Question91: Which CAS action is used to export data from the CAS environment?

Question92: If a dictionary named res contains a table named fetch, which statement will print the table?

Question93: Using the altertable action, which is the correct statement to rename the make column to veh_make in a CAS table?
proc cas;
table.altertable / caslib="casuser", name="cars",
<enter code segment here>;
quit;

Question94: In the deduplication.deduplicate action, which parameter eliminates rows with duplicate group-by variable values?

Question95: Which CASL program will fetch all 428 rows from the cars table?

Question96: Which CAS action is used to load data from an external file into a CAS table?

Question97: Which SAS Viya procedure is used for data exploration and analysis?

Question98: Which CAS-enabled procedure is used to perform clustering analysis on CAS tables?

Question99: Given the following program:
data casuser.noInput / sessref=casauto;
x=1;
run;
Which statement is true?

Question100: Which CAS-enabled procedure allows the use of user-defined formats for data summarization?

Question101: Which table.update parameter specifies the column to update?

Question102: Which CAS-enabled procedure is used for regression analysis and modeling?

Question103: In the following code, complete the PRINT statement to print only rows where column begins with MPG:
proc cas;
simple.summary result=res / table={name="cars"};
resultTable = res.summary;
print <insert code segment here>;
run;

Question104: How can you associate a user-defined format with a variable in SAS?

Question105: Which PROC CAS step will transpose the CLASS table so that the values of the NAME column are used to create the column names in the output table?

Question106: Which of the following statements about the CAS server is true?

Question107: Which statement is used to define a user-defined format in SAS Viya?

Question108: Which CASL program correctly runs two DATA step programs that are stored in separate source blocks named Program1 and Program2?

Question109: In SQL programming, which statement is used to filter rows based on conditions?

Question110: What is the primary purpose of using the DATA step in CAS programming?

Question111: Which CAS action is used to split a string variable into multiple variables based on a delimiter in a CAS table?

Question112: Which CAS action is used to perform data quality checks on variables in a CAS table?

Question113: Which CAS action is used to retrieve a subset of rows and columns from a CAS table?

Question114: Assume all caslib names follow libref naming conventions.
Which code assigns librefs of the same name to each caslib?

Question115: What is the purpose of the CNTLIN option in PROC FORMAT?

Question116: Which CAS-enabled procedure is used to perform data partitioning?

Question117: In which situation is it best to leverage the CAS server?

Question118: How can you define a user-defined format in SAS?

Question119: Which CAS action is used to perform data profiling to analyze the distribution of values in a CAS table?

Question120: Which CAS statement is used to select specific columns from a CAS table?

Question121: Given the following log output:
- NOTE: The WHERE data set option on the DATA statement is not supported with DATA step in Cloud Analytic Services.
- NOTE: Could not execute DATA step code in Cloud Analytic Services. Running DATA step in the SAS client.
- NOTE: There were 19 observations read from the data set CASUSER.CLASS.
- NOTE: The data set CASUSER.CLASS2 has 1 observations and 5 variables.
Which DATA step program produced the above log output?

Question122: In the space provided, enter the text for ensuring the table is available to any subsequent CAS session.
table.loadTable / caslib="public", path="sales.xlsx",
casOut={caslib="public", name="sales",______=true};

Question123: Which CAS action is used to create a new CAS table by concatenating two or more existing CAS tables?